Re: [SQL] different between || and && in a statement

At 21:43 +0200 on 25/10/1999, Christian Guenther wrote:


> Whats the different between the logical expression && and || and is there
> a way to get && working?

It's really not clear what you are trying to achieve here. Neither || nor
&& are logical operators. In Postgres, || is string concatenation, not
"or". What you would get in sum(...) || sum( ... ) is the concatenation of
the two sums. If one is 32 and the other 17, you'd get 3217.

In any case, what sense does a logical operator have between two integers?
Logical operators should connect between logical operands. But the sums are
sums of integers. There is no such thing as a boolean sum. Unless you meant
to do a cumulative "or" operation between all the rows that have the proper
string value? In that case, you really have to build a custom aggregate for
it.

In any case, in SQL, the word for "or" is... OR. The word for "and" is AND
and the word for "not" is NOT.

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma